Properties that use Expressions

The following table lists the report design properties that allow expressions to be defined.

Component	Description
Page Header	Log URL
Chart	Show Grid Line in Chart Chart Series Chart Value - Plot Data As Line
Cross Tabs	Data Fields Displays Links Width Image URLs
Group	Group By Make Group Visible Show Group Display Show Summary Column in Group Repeat on every new page Display Group By Footer value
Data Column	Show Data Column Value Show Data Column Label Translate Label Link data Value Format Date Value Format Data Value Color Format Data Column Background Color Format Data Value Font Family Show URL in Data Value

Example Detail Link References

Detail Link	Field Used (Item ID)
Complaint	PK ID Code.BuildSmartSolveUrl("SS_COMPLAINT",{\|PK_ID\|A.PK_ID\|})+"&EntityType=SS_COMPLAINT&FormKey=SS_COMPLAINT_DETAIL"
Audit	PK ID Code.BuildSmartSolveUrl("SS_AUDIT”, {\|PK_ID\|A.PK_ID\|})+”&EntityType=SS_AUDIT&FormKey=SS_AUDIT_DETAIL”

Detail Link

Field Used (Item ID)

Complaint

PK ID

Code.BuildSmartSolveUrl("SS_COMPLAINT",{|PK_ID|A.PK_ID|})+"&EntityType=SS_COMPLAINT&FormKey=SS_COMPLAINT_DETAIL"

Audit

PK ID

Code.BuildSmartSolveUrl("SS_AUDIT”, {|PK_ID|A.PK_ID|})+”&EntityType=SS_AUDIT&FormKey=SS_AUDIT_DETAIL”

Timeline Expressions

Expression	Configuration
Action Plan Timeline Status	Data Field IIF(DateDiff(DateInterval.Day, {\|Action Plan Due Date\|H.RAP_DUE_DATE\|}, {\|Action Plan Completed Date\|H.RAP_COMPLETED_DATE\|})<= "0", "On Time", "Over Due") Background Color IIF(DateDiff(DateInterval.Day, {\|Action Plan Due Date\|H.RAP_DUE_DATE\|}, {\|Action Plan Completed Date\|H.RAP_COMPLETED_DATE\|})<= "0", "#00FF00", "#FF0000")

Expression

Configuration

Action Plan Timeline Status

Data Field

IIF(DateDiff(DateInterval.Day, {|Action Plan Due Date|H.RAP_DUE_DATE|}, {|Action Plan Completed Date|H.RAP_COMPLETED_DATE|})<= "0", "On Time", "Over Due")

Background Color

IIF(DateDiff(DateInterval.Day, {|Action Plan Due Date|H.RAP_DUE_DATE|}, {|Action Plan Completed Date|H.RAP_COMPLETED_DATE|})<= "0", "#00FF00", "#FF0000")